<?php

class DermatoController extends Site_Controller_Action
{

    public function init()
    {
        /* Initialize action controller here */
    }

    public function indexAction()
    {
        $query = 'SELECT SQL_CACHE * FROM DEMARTO WHERE DMT_STA = 1';
        $result = $this->db->fetchRow($query);
        $this->view->result = $result;
        
        // galeria
        $where = ' GAL_MOD LIKE "demarto"';
        //$where .= ' AND GAL_MODNUM = '.$ctl_id;
        $query = 'SELECT SQL_CACHE * FROM GALERIA WHERE '.$where.' ORDER BY GAL_ORD ASC';
        $result = $this->db->fetchAll($query);
        $this->view->galeria = $result;
        
    }

}

